<?xml version="1.0" encoding="ISO-8859-1" ?>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1" import="java.io.*,java.sql.*, java.util.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@page import="dbAccess.DbAccess, dbAccess.Login"%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Just a test page.</title>
<link rel="stylesheet" type="text/css" href="css_files/style.css" />
</head>
<body>
<%
DbAccess access = new DbAccess();
Login login = new Login();

ResultSet rsx = access.ExecuteSelect(access.connect("jdbc:mysql://localhost:3306/test","root","test"), "SELECT * FROM tbl_occupationMapping");
out.println("testing the DbAccess.ExecuteSelect method: ");
while (rsx.next())
	{
		out.println(rsx.getString("OccupationDesc"));
		out.println(rsx.getString("OccupationCode"));
	}
rsx.close();
access.connect("jdbc:mysql://localhost:3306/test","root","test").close();

out.println("testing the DbAccess.ExecuteScalar method: ");
out.println(access.ExecuteScalar(access.connect("jdbc:mysql://localhost:3306/test","root","test"), "SELECT OccupationDesc FROM tbl_occupationMapping"));

out.println("testing the login method: ");
out.println(login.UserLogin("john@hotmail.com", "noodles"));



%>

</body>

</html>